package com.example.demo;

import java.sql.Connection;
import java.sql.DriverManager;

public class DBConnection {
    private String FileName;
    private  int DBType;
    private Connection conn;
    private  String MySqlDriver;
    private  String MySqlURL;
    public  DBConnection(){
        conn=null;
    }
    public  Connection getConn()
    {
        DBType=1;
        switch (DBType)
        {
            case  1:return(getConnToMySql());
            default:return null;
        }
    }
    public Connection getConnToMySql()
    {
        try {
           MySqlDriver="com.mysql.cj.jdbc.Driver";
           MySqlURL="jdbc:mysql://172.21.32.100:3306/unit7website?user=root&password=123456&useUnicode=true&characterEncoding=UTF-8";
           Class.forName(MySqlDriver).newInstance();
           conn= DriverManager.getConnection(MySqlURL);
        }catch (Exception e){
        }
        return conn;
    }
}
